﻿14.4.2013 21:43:10
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 21:43:10
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('14.4.2013 21:43:10', 'dd/mm/yyyy hh24:mi:ss'), 
 2) ; SELECT @@Identity

14.4.2013 21:43:10
DECLARE @idRole int = 1;--1 
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
where 
idModul not in 
(
--Select vraci vsechny idModul, ktere maji byt neviditelne pro danou roli 
select Modul.idModul 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = @idRole and visible = 0 
) 
order by idParent, orderModul

14.4.2013 21:43:15
UPDATE Login SET 
logout = to_date('14.4.2013 21:43:15', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 333 

14.4.2013 21:54:26
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:05:14
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:05:14
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('14.4.2013 22:05:14', 'dd/mm/yyyy hh24:mi:ss'), 
 2) ; SELECT @@Identity

14.4.2013 22:05:14
DECLARE @idRole int = 1;--1 
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
where 
idModul not in 
(
--Select vraci vsechny idModul, ktere maji byt neviditelne pro danou roli 
select Modul.idModul 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = @idRole and visible = 0 
) 
order by idParent, orderModul

14.4.2013 22:05:17
UPDATE Login SET 
logout = to_date('14.4.2013 22:05:17', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 334 

14.4.2013 22:06:07
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:06:07
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file G:\ProjectsSVN\trunk\Pruzkumnik\Debug\DbPruzkumnik.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBManager.SqlManager.Select(String sql_, DataTable& dataTable_, Dictionary`2 parametry) in G:\ProjectsSVN\trunk\Pruzkumnik\DBManager\SqlManager.cs:line 230

14.4.2013 22:06:14
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:06:14
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file G:\ProjectsSVN\trunk\Pruzkumnik\Debug\DbPruzkumnik.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBManager.SqlManager.Select(String sql_, DataTable& dataTable_, Dictionary`2 parametry) in G:\ProjectsSVN\trunk\Pruzkumnik\DBManager\SqlManager.cs:line 230

14.4.2013 22:09:41
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:09:41
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('14.4.2013 22:09:41', 'dd/mm/yyyy hh24:mi:ss'), 
 2) ; SELECT @@Identity

14.4.2013 22:09:42
DECLARE @idRole int = 1;--1 
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
where 
idModul not in 
(
--Select vraci vsechny idModul, ktere maji byt neviditelne pro danou roli 
select Modul.idModul 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = @idRole and visible = 0 
) 
order by idParent, orderModul

14.4.2013 22:09:44
UPDATE Login SET 
logout = to_date('14.4.2013 22:09:44', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 336 

